MySQL Pocket Reference: SQL Functions and Utilities, 2/e

購買商店

MySQL Pocket Reference: SQL Functions and Utilities, 2/e

$473.00

馬上購買

內容描述

Description

To help you be more efficient in your work,
this handy pocket reference gives you instant reminders on how to use
important MySQL functions, especially in conjunction with key parts of the
LAMP open source infrastructure. This powerful database system is so rich in
features that no administrator or programmer can stay familiar with all of
them. MySQL Pocket Reference is an ideal on-the-job companion, well
organized to help you find and adapt the statements you need --
quickly.Updated for the latest versions of this popular database, this
edition covers many complex features that have been added to MySQL 5.0 and
5.1, including a section dedicated to stored procedures and triggers. After a
brief introduction on installation and initial setup, the book explains:

How to configure MySQL, such as setting the root password
MySQL data types, including numerics, strings, dates, and complex types
SQL syntax, commands, data types, operators, and functions
Arithmetic, comparison and logical operators
Aggregate and general functions
Stored procedures and triggers, including procedure definition,
procedure calls, procedure management, cursors, and triggers You
don't have time to stop and thumb through an exhaustive reference when you're
hard at work. This portable and affordable guide is small enough to fit into
your pocket, and gives you a convenient reference that you can consult
anywhere. When you reach a sticking point and need to get to a solution
quickly, the MySQL Pocket Reference is the book you want to
have.
Table of Contents

Introduction       MySQL 5  
             Views 
               Triggers 
               Stored
Procedures           
     Cursors         
       New Storage Engines   
             Database Events 
     Setup         
       Downloading MySQL     
           Configuration 
               Startup 
               Set the
Root Password           
     Replication     
 Command-Line Tools       Data Types 
              
Numerics           
     Strings         
       Dates       
         Complex Types   
   SQL           
     Case Sensitivity       
         Literals     
           Identifiers 
               Comments 
              
Commands           
     Transaction Rules     
 Operators           
     Rules of Precedence     
           Arithmetic Operators 
              
Comparison Operators           
     Logical Operators     
 Functions           
     Aggregate Functions     
           General Functions 
     Storage Engines       Stored
Procedures and Functions           
     Parameters         
       Logic       
         Handlers and Conditions 
     Triggers 
Index